Diagram replication

CADMATIC CoDesigner allows project sites to synchronize CADMATIC P&ID data over the COS network. Designers can select whether to use online or offline replication.

CoDesigner for P&ID is enabled from the SQL database settings on the master site of the project. SQL database replication is based on standard COS object replication. Replication is done immediately for critical changes such as changes to the SQL database schema. A normal operation such as editing a diagram is replicated within the defined replication interval.

After the replication, the project sites interpret the changes in the diagrams and synchronize their own diagram databases accordingly. This synchronization starts when a designer opens the P&ID application or browses or checks out a specific diagram. This action completes the replication process.

• Diagram replication
• Administrating diagram replication
• Get started with diagram replication

Administrating diagram replication

Mixed mode is not supported. When the Replicate P&I Diagrams setting in Manage Project is set to "CoDesigner ON", every site must have their own name for the database if they exist on the same SQL server. The database can be on the same SQL Server, but they need to be separate instances. When Replicate P&I Diagrams is set to "CoDesginer OFF", every site is connected to the main site's SQL database. The name of the SQL Server must be exactly same in each site. Administrator can see information about the configuration in each site when P&ID is opened.

When the CoDesigner mode is in use, the database schema can only be managed at the master site. The replica schemas are synchronized by the replica administrator when opening the P&ID application. Administrators should do the schema updates at a time when the users are not editing the diagrams.

To keep the databases synchronized with COS, a Plant Modeller Service Instance can be set to run diagram replication at scheduled times. See Diagram tab.

Get started with diagram replication

The following steps are needed to start replication in an on-going project.

• Start the P&ID application at the main site.
• Make sure that all sites have replicated to the master.
• Turn CoDesigner replication ON at the main site from SQL Settings.
• At the satellite site, define an own database name from SQL settings.
• At the satellite site, change the username of P&ID Administrator from SQL settings to a user who is System Administrator and can open the P&ID application.
• Turn CoDesigner replication ON at all satellite sites.
• Create the satellite site SQL database from the CADMATIC desktop, from Object > Manage Diagram Database.
• Open the P&ID application once in all sites to initialize the environment.

Note: If there are SQL schema changes in the main site after the CoDesigner for P&ID has been started, the satellite site's P&ID Administrator must start the P&ID application to initialize the change.